package com.gljx.web.dao;

import com.gljx.web.Entity.Sharecarsub;
import com.gljx.web.Entity.Sharecarsubentry;
import org.apache.ibatis.annotations.Param;

import java.lang.reflect.Type;
import java.util.List;

import org.springframework.stereotype.Component;

@Component
public interface SharecarsubMapper {
    int deleteByPrimaryKey(String fid);

    int insert(Sharecarsub record);

    int insertSelective(Sharecarsub record);

    Sharecarsub selectByPrimaryKey(String fid);

    int updateByPrimaryKeySelective(Sharecarsub record);

    int updateByPrimaryKey(Sharecarsub record);

    //查询练车时间对应的学生 用于自动分车
    List selectStudentByAutoCar(String cflcsjid);

    //练车时间 cflcsjid 预约类型 cfbilltype 车型 cfsqzjcxdh
    List<Sharecarsub> selectpractiseOrderList(@Param("cflcsjid") String cflcsjid, @Param("type") String type);

    List<Sharecarsub> selectSharecarsubentryXls(@Param("cflcsj") String cflcsj, @Param("cfstudentname") String cfstudentname,
                                                @Param("cfidcardno") String cfidcardno, @Param("cfmobile") String cfmobile,
                                                @Param("subject") String subject, @Param("beginTime") String beginTime,
                                                @Param("endTime") String endTime, @Param("fcompanyid") String fcompanyid);

    /**
     *
     * @param cflcsj
     * @param cfstudentname
     * @param cfidcardno
     * @param cfmobile
     * @param subject
     * @param beginTime
     * @param endTime
     * @param type
     * @return
     */
    List<Sharecarsub> selectSharecarsubentryXlss(@Param("cflcsj") String cflcsj, @Param("cfstudentname") String cfstudentname,
                                                @Param("cfidcardno") String cfidcardno, @Param("cfmobile") String cfmobile,
                                                @Param("subject") String subject, @Param("beginTime") String beginTime,
                                                @Param("endTime") String endTime, @Param("type") String type,@Param("fcompanyid") String fcompanyid);

    List<Sharecarsub> selectSharecarsubentryXlsAsWx(@Param("cflcsj") String cflcsj, @Param("cfstudentname") String cfstudentname,
                                                    @Param("cfidcardno") String cfidcardno, @Param("cfmobile") String cfmobile,
                                                    @Param("cfcomputationtimestate") String cfcomputationtimestate,
                                                    @Param("subject") String subject, @Param("beginTime") String beginTime,
                                                    @Param("endTime") String endTime, @Param("fcompanyid") String fcompanyid);

}